﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Dropthings.DAL
{
    public class UQ_GetPorperties : BaseQuery
    {
        public UQ_GetPorperties()
            : base()
        {
            StringBuilder sqlStr = new StringBuilder();
            sqlStr.Append("select OrgPropertyCode, OrgPropertyName FROM DB_OrganizePropertyInfo");
            sqlStr.Append(" order by OrgPropertyCode");
            _QueryStringName = sqlStr.ToString();
        }
    }


    public class UQ_GetOrganizePorpertyInfo : BaseQuery
    {
        public UQ_GetOrganizePorpertyInfo(string propertyCode)
            : base()
        {
            _QueryStringName = "select OrgPropertyCode, OrgPropertyName FROM DB_OrganizePropertyInfo where OrgPropertyCode='" + propertyCode + "'";
        }
    }

    public class UQ_GetOrganizeBaseInfoForReportView : BaseQuery
    {
        public UQ_GetOrganizeBaseInfoForReportView(string identifyCode)
            : base()
        {
            _QueryStringName = string.Format("select OrganizeName,OrganizeAddress,PhoneNum,OrganizeCode,Postalcode,EMailBox,FaxNum from DB_OrganizeBaseInfo where OrganizeIdentify='{0}'",
                identifyCode);
        }
    }
}